GoldenGate Bridges the gaps between Production and BCP
Oracle GoldenGate is used as part of our business continuity plan. We use it to replicate in near realtime, transactions from the primary …
Starting at $250 Per License
View PricingOverview
What is Oracle GoldenGate?
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
Data Integration
$250.00
Cloud
Per License
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://cloud.oracle.com/en_US/goldenga…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Oracle Goldengate demo
YouTube
Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_31st May
YouTube
2017 05 19 22 04 Oracle Goldengate Demo
YouTube
Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_14 June
YouTube
Oracle 12c Golgen Gate Essentials Training - DEMO
YouTube
Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux
YouTube
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
What is Oracle GoldenGate?
Oracle GoldenGate products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables:
-Real-time business intelligence and stream analytics for improved business insight
-Query offloading to maximize OLTP performance
-Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability
Datasheet - https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf
Datasheet (Stream Analytics) https://www.oracle.com/us/products/middleware/data-integration/oracle-stream-analytics-ds-4478221.pd...
Analyst whitepaper https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf
Documentation
Video Oracle GoldenGate Cloud Service - Get an overview of this cloud based real-time data integration and replication service that provides quick, easy, accurate and safe data movement to the cloud. https://youtu.be/liBgUwHgVew
Oracle GoldenGate Video
GoldenGate Cloud for real-time replication
Oracle GoldenGate Integrations
Oracle GoldenGate Competitors
Oracle GoldenGate Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Oracle GoldenGate Downloadables
Frequently Asked Questions
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Azure Data Factory, AWS Database Migration Service, and Informatica Cloud Data Integration are common alternatives for Oracle GoldenGate.
Reviewers rate Oracle Implementation Satisfaction highest, with a score of 9.7.
The most common users of Oracle GoldenGate are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(221)Attribute Ratings
Reviews
(1-8 of 8)Companies can't remove reviews or game the system. Here's why
December 04, 2020
Oracle GoldenGate Review
We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tons of applications to assign installation and repair jobs to field technicians. In some of the applications, we can't afford latency or replication errors. GoldenGate has been a great tool.
- I was able to find what I needed, but it took longer than I think it needed to. The system was navigable, but not until I had training on it. Before that I was clueless on how to find anything.
- It allows the replication in real time from the Oracle database in RAC to the contingency database, through the immediate replication of the data in the redo logs, without the need to wait for them to be written at the level of the archive logs.
- You can have multiple different data sources coming into this Oracle GoldenGate. You are not limited to only Oracle databases.
- The time that it takes to implement Oracle GoldenGate. Because you can have multiple databases going through it it can take a long time to set it up.
- It was more complicated than it needed to be. Without the training I feel that it isn't intuitive. I think maybe the structure should be reinvented so that it is more intuitive.
- GoldenGate replication is only for databases, it would be nice to use it across file and folders
We have been using Oracle GoldenGate (OGG) for our replication needs. We have a mix of database environments including Oracle, DB2 and Microsoft SQL Server. We use Oracle GoldenGate to replicate across the mix of these different RDBMS. OGG is reliable, fast, has high throughput and allows heterogeneous replication.
We also use OGG Management Pack which is an extra license cost and includes Oracle GoldenGate Monitor, Oracle GoldenGate Director and Oracle GoldenGate Veridata.
We also use OGG Management Pack which is an extra license cost and includes Oracle GoldenGate Monitor, Oracle GoldenGate Director and Oracle GoldenGate Veridata.
- Supports both homogeneous and heterogeneous replications.
- Supports DDL replication if both source and target databases are Oracle.
- Supports multiple replication topology such as unidirectional, bi-directional, cascading, peer to peer and multicasting.
- Can interface with JMS and Big Data Systems.
- Like most Oracle products, it is quite expensive.
- Too many tables in single replication channels creates performance bottlenecks. You have to split your tables into multiple channels.
November 07, 2018
MyCentsonGold
We are using this application to replicate data from one data center to other data center. And it's very accurate and it's solved our data issues during the down time the replication helped not loosing of business and with little impact to customer for check out and creating profiles
- Well organized and greater data integration
- Response Time(no latency) able to sustain the load during the process
- Because of Golden Gate our business able to deliver the continuance and high availability of the application
- Less hassles of maintenance
- Little more flexibility and should be more robustness
- Need improvement on session management
- Replication takes more time - you need a better approach with less time
October 30, 2017
Different Source Systems (IBM DB2, Microsoft SQL Server) Are Supported For Real Time Replication.
Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now am able to replicate Big Data solution from any supported source system to Hadoop clusters.
- Ease of installation
- Ease of maintenance
- Powerful output with sub-second speed
- Supporting Big Data and Cloud environment
- Capturing source data based on transnational log, no cost on source CPU
- Handle the distribution and the delivery of committed data in real-time
- Supports heterogeneous systems regarding target or source database
- Can be implemented uni-directional, bi-directional or peer-to-peer mode
- Zero downtime migration
- Supports data distribution
- Can be used for disaster recovery or data protection
- Oracle GoldenGate Studio could be more user-friendly.
- It would be better for Oracle Golden Gate Studio GUI to include other OGG related licensed products (i.e. Veridata or others).
October 25, 2017
Oracle GoldenGate for real time replication
We use Oracle databases as the primary data storage facility for our university. We have many ERP products that need to integrate with custom applications designed to support our IT infrastructure. We decided to use Oracle GoldenGate as a means of keeping data in sync between our ERP system and a temporary data-cache. It offers real-time replication of data between different database systems.
- I think it's a very useful tool that can provide live transactional data across heterogeneous environments.
- Oracle GoldenGate allows you to configure data mapping between different tables using simple configuration files.
- The licensing agreement that we had for GoldenGate did not include an admin visual console to monitor the different replication processes in real time.
- Once a replication process gets abended due to some data load error, the product does not skip onto the next record to continue replication. This was one feature we really needed.
February 15, 2017
Expensive but not worth on DB2
We are using Oracle GoldenGate to replicate data between data centers.
- It supports multiple data sources including IBM/Oracle/Microsoft
- Natively supports Oracle, but not DB2
- Has the flexibility for CDR
November 23, 2016
Real time replication in a Heterogeneous environment
We're in a data warehousing project where we need to replicate from multiple source/intermediary systems (MS SQL Servers and Sybase) into Oracle as our reporting platform. GoldenGate fulfilled our needs of having a reliable means of extracting live data from multiple heterogeneous databases and feed into an EDW. In that sense, it's an invaluable tool for the report writers and business analysts across the organization. There are some hiccups here and there, mostly having to do with some data transformations and certain long transactions, but overall, it performs reliably well and better than other alternative replication products we're tried.
- GoldenGate can handle multiple database vendors (SQL Server, Sybase, DB2, Enscribe, etc.) and replicate data in real-time.
- It's flexible and can perform data transformation/cleansing on the fly when you provide the mapping file for it. Exceptionally good error handling and data collision handling. Over some years, we have some large tables with 10 million records or more, and have seen only a very few records missing/incorrect.
- Good support responses. GoldenGate was well-supported when it was an independent company, and even though Oracle acquired it, it still has a good support organization.
- It's expensive. And I believe you have to purchase a license for each type of source and/or target DB that you're trying to replicate.
- It will be slow for a single transaction that updates a large number of rows. It's better to break up such transactions into batches and run them in a loop with periodic commits (Batch Insert or Batch Update).
- It's buggy when reading SQL Server transaction logs; may cause an abend.
November 06, 2015
Oracle GoldenGate, it's not just for Oracle DBs anymore!
At a previous job, bi-directional Oracle GoldenGate replication was used to support a highly available application model. It was used across the whole IT DBA organization. At my current position Oracle GoldenGate is being used in a uni-directional manner to replicate data from 10 different application databases to an ERP platform that is used for our enterprise reporting needs, this also helps in offloading the reporting from the application databases.
- Replication. Oracle GoldenGate's strength is it's main feature, replication. GoldenGate is able to quickly replicate transactions in a method that maintains transactional integrity and give you a like to like replica on the other side.
- Transformation. Oracle GoldenGate is able to do some data transformation as it replicates, this is very key if you need your data to appear a certain way, especially important in Reporting.
- Recoverability. Oracle GoldenGate has many fail safes to ensure data is not lost, some examples of this are trail files its own system of recording changes that works with the DB SCN.
- Multiple Data Sources/Targets. Oracle GoldenGate is not limited to just Oracle Databases as a target it can support most of the popular databases in the industry today such as SQL Server, MySQL, DB2 and more.
- Setting Up Oracle GoldenGate as HA in an Oracle RAC environment. While this is possible to do and there is documentation out there, I've found that specific Oracle GoldenGate and Oracle RAC experience is needed in order to make this happen. That level of experience does not exist everywhere.
- Monitoring Oracle GoldenGate. Currently there are two main options for monitoring Oracle GoldenGate, the first, GoldenGate Monitor, does not scale well as it becomes very non-performant when you have more than 10-15 GoldenGate Managers reporting to it, the second, Oracle Enterprise Manager, while getting better still requires a lot of manual configuration to have Oracle GoldenGate talk to the OEM agent. While this has got a lot better with 12c GoldenGate, I still feel that there is room to improve here.
- Unable to replicate certain Data Types. Again, less of an issue in 12c Oracle GoldenGate, but there are still some Data Types that Oracle GoldenGate is unable to replicate.